DROP LOGIN DeMaSy;CREATE LOGIN [DeMaSy] WITH PASSWORD = ‘demasy’, DEFAULT_LANGUAGE = [French],CHECK_POLICY = OFF; Create Database Licence COLLATE SQL_Latin1_General_CP1_CI_AS; Alter Database Licence Set AUTO_SHRINK ON; Use Licence; CREATE SCHEMA DeMaSy; CREATE USER DeMaSy FOR LOGIN DeMaSy WITH DEFAULT_SCHEMA = DeMaSy; exec sp_addrolemember ‘db_owner’, ‘DeMaSy’; exec sp_addrolemember ‘db_accessadmin’, ‘DeMaSy’; exec sp_addrolemember ‘db_securityadmin’, ‘DeMaSy’; exec sp_addrolemember ‘db_ddladmin’, … Continue reading Query: Create SQL Database